[]
Sorts all the rows on this sheet by the specified column.
public bool SortRows(int keyColumn, bool ascending, bool showIndicator)
Public Function SortRows(keyColumn As Integer, ascending As Boolean, showIndicator As Boolean) As Boolean
Type | Name | Description |
---|---|---|
int | keyColumn | Column index whose values are compared during sorting |
bool | ascending | Whether to sort in ascending order |
bool | showIndicator | Whether the sort indicator should be displayed |
Type | Description |
---|---|
bool |
Sorts all the rows on this sheet by the specified column using the specified comparison.
public bool SortRows(int keyColumn, bool ascending, bool showIndicator, IComparer comparer)
Public Function SortRows(keyColumn As Integer, ascending As Boolean, showIndicator As Boolean, comparer As IComparer) As Boolean
Type | Name | Description |
---|---|---|
int | keyColumn | Column index whose values are compared during sorting |
bool | ascending | Whether to sort in ascending order |
bool | showIndicator | Whether the sort indicator should be displayed |
IComparer | comparer | IComparer object used to compare the values |
Type | Description |
---|---|
bool |
Sorts all the rows on this sheet by the specified column using the specified comparison.
public bool SortRows(int keyColumn, bool ascending, bool showIndicator, IComparer comparer, bool sortFrozenRows, bool sortTrailingFrozenRows)
Public Function SortRows(keyColumn As Integer, ascending As Boolean, showIndicator As Boolean, comparer As IComparer, sortFrozenRows As Boolean, sortTrailingFrozenRows As Boolean) As Boolean
Type | Name | Description |
---|---|---|
int | keyColumn | Column index whose values are compared during sorting |
bool | ascending | Whether to sort in ascending order |
bool | showIndicator | Whether the sort indicator should be displayed |
IComparer | comparer | IComparer object used to compare the values |
bool | sortFrozenRows | Whether frozen rows are sorted |
bool | sortTrailingFrozenRows | Whether trailing frozen rows are sorted |
Type | Description |
---|---|
bool |
Sorts a range of rows on this sheet according to the specified sort information.
public bool SortRows(int row, int rowCount, SortInfo[] sortInfo)
Public Function SortRows(row As Integer, rowCount As Integer, sortInfo As SortInfo()) As Boolean
Type | Name | Description |
---|---|---|
int | row | Index of first row in range to sort |
int | rowCount | Number of rows in range to sort |
SortInfo[] | sortInfo | Array of SortInfo objects with the column indexes and sort order |
Type | Description |
---|---|
bool |